Find percentage of double false pairs within five two column sets

Question

Find percentage of double false pairs within five two column sets

The situation is that I have four sets of two related columns, and those four sets are repeated over 17 sheets. They are all check boxes (basically and either or), and I've already got it set up to do quite a bit when one of the two is checked.

What I'm looking to figure out is whether it's possible to indicate the percentage of a two column pair both being false. I want to compare, over time (represented by all the sheets), how each column pair does.

Here's a screen shot. Currently, I'm manually marking the double false rows with red, but I'd like my 18th sheet, which collects information about the rest, to display quickly how well each of the column pairs is doing.

iMac, OS X El Capitan (10.11.5)

Posted on Sep 16, 2016 1:30 PM

Reply

Answer 1

Sep 17, 2016 6:09 AM in response to myCompliments

you can count double falses using the formula:

=COUNTIFS(A, FALSE, B, FALSE)

Perhaps showing some of you could show move of whats on a sheet, show the tables names, and what's on sheet 18.

This will allow us to provide a solution specific to your situation

Reply

Answer 2

Sep 17, 2016 6:09 AM in response to Wayne Contello

What I meant was....

"Perhaps showing some of you could show move of whats on a sheet, show the tables names, and what's on sheet 18."

should have read:

Perhaps showing some of what you have done and more of whats on a sheet, show the tables names, and what's on sheet 18.

Reply

Answer 3

Sep 17, 2016 6:08 AM in response to Wayne Contello

That's great, I missed that somehow. Thank you!

I kept the other parts out for clarity, but this is exactly the solution I need. I can total double false column pairs and then pull each sheet's total into sheet 18.

Here's a full shot of the double column setup. In this case, uncertainty counts against average. Sheet 18 doesn't have anything on it right now that has to do with this, but now that I know about COUNTIFS, it will. Or, maybe just a rolling average per sheet. Each sheet is going to get a quick assessment of uncertainty.

"Result" is totaling against real world results, and feeding into different stats on sheet 18.

Reply